package com.example.demo2.mapper;

import com.example.demo2.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface PmcMapper {

    @Select("select * from permissionconnection where uID=#{uID}")
    List<PermissionConnection> findPmcByUID(@Param("uID") Integer uID);

    @Select("select permissionconnection.pmcUrl from permissionconnection where pmcId=#{pmcId}")
    String findPmcUrlByPmcId(@Param("pmcId") Integer pmcId);
}
